In a word: DON'T
The exception is if you still haven't gotten around to transferring something like your old VHS tapes, which does work well on Video DVDs, **If** you can still find the required hardware, e.g. a DVD recorder, or a analog capture device that will work with your PC/laptop.
Yes, the old standard size video still exists, and it's watched on the majority of TV channels, & that's what you might [unfortunately] get if you're streaming but have low bandwidth [when the connection isn't fast enough for the larger HD or 4k files]. But if you're getting & using new content, HD is almost certainly available. Use it. 4k TVs are becoming the default or standard -- in the future it's going to only get harder to find a new HD rather than 4k TV -- and DVD-sized video just isn't that watchable on a 4k TV. Any video DVDs you create are going to have a short life span.
The ONLY advantage video DVDs have is their relatively simple, 20+ year old menu structure. You can mimic most DVD menu features using video Blu-ray, with the downsides that the Blu-ray discs you might burn have questionable compatibility & longevity, and since Blu-ray isn't nearly as popular as DVDs were at their peak, not everyone you might give your discs to will have a Blu-ray player or drive. If you want/need menus, and if you want to give your work to other people, IMHO the closest thing to a good overall modern solution is to use Blu-ray on DVD if you want to store your creation on disc, or regular Blu-ray files played from something like a hard drive or USB stick etc., since Blu-ray video itself is playable on a wide variety of devices, from smart TVs to Android boxes to cell phones etc. with the right software. The downsides of Blu-ray on DVD are you're limited to at most 8GB, and it's a bit more difficult to find software that will create Blu-rays that are 8GB or less vs. standard Blu-ray at 25 & 50 GB.
RE: Video DVD &/or Blu-ray creation software...
There was never any intent to design the Video DVD spec, or the newer Blu-ray spec, for anyone outside the professionals at the studios in Hollywood. It cost thousands of dollars *If* they'd even sell you the specs. Windows software for creating video DVDs & Blu-rays uses a Very High level of abstraction -- what you see and the tools you use are far removed from the actual DVD & Blu-ray discs that are created -- so that software varies quite a bit from one brand to the next. Lots of that software, including the large number of apps based on the open source DVDAuthor, produces a video DVD structure that's not really off spec, but very different from both what more pro software creates, and what's seen on retail video DVDs and Blu-rays. DVD and Blu-ray players are designed to play retail video DVD & Blu-ray discs, and anything different might or might not play, depending on the brand and model of player.
I think that high level of abstraction I mentioned is responsible for the limited feature sets in most DVD creation or authoring software, e.g. today's Apeaksoft DVD Creator. When you use an image editor you directly effect the pixels in the image, and the software developer provides you tools to manipulate those pixels. Pretty straight forward. With video DVDs & Blu-rays developers can't tell or show you what you're actually doing in their software... You're in effect writing code, but the NDA prevents them from telling or showing you anything about that code, *IF* the developers ever had the spec to begin with, or as is common, are working from knowledge gained by reverse engineering combined with trial & error. As a result, in a nutshell anyway, the developers figure out a way to do things, and then add those to their software. Some developers, e.g. Apeaksoft, stop at the very basics [Apeaksoft is far from alone BTW], while others spend the resources to go further. With the right software you can create & control every aspect of the DVD or Blu-ray, creating something that's comparable to what you see retail, if you want to spend the money [when necessary], master the learning curve, and do the work -- it's time consuming to create the video & audio loops for menus, the links/highlights display, menu structure/options etc., vs. making just a few choices and letting Apeaksoft DVD Creator do its thing.
At this point I need to add that most retail Blu-ray video discs use Java for the menus & options, together with parts of their DRM. Authoring software that lets you use Java is hugely expensive, so apps like Apeaksoft DVD Creator translate their limited DVD menu options to a sort of fall back feature in the Blu-ray spec, letting you do relatively simple stuff while skipping Java entirely. For most people that's probably OK -- there's not a huge demand for disc authoring software anymore, and the market has sort of devolved... Some big name companies like Adobe are out of the game, while others continue to sell their old wares, which are pretty much the same as they were 5+ years ago. Those companies producing the Java-enabled Blu-ray creation apps see no reasons to drop prices, so anyone outside a Hollywood studio might be interested, while the DVDAuthor code included in so many apps hasn't been updated in a couple of years now.
Info RE: Video DVDs themselves [if you must create video DVDs]...
Long story short, video DVDs are pretty darn complicated -- they're based on a minimal sort of programming language that's stored as numbers in registers that a DVD player reads & understands. BUT, not all of the spec's rules are obeyed, while not all of the commands or features included in the video DVD specs are actually used in retail DVDs, and so are Not implemented in any players. Talking about some of this complexity isn't meant to scare you as much as it's intended to help you set realistic expectations [do you really imagine a simple, basic app would do all of this], and maybe point you in the right directions if something doesn't work as hoped in a DVD you made using something like the minimal Apeaksoft DVD Creator. Then again, it also hints at the learning curve if you decide to do something more involved that a pretty simple DVD or Blu-ray video disc.
A sort of side note, another thing to consider is the video itself... X264 is a great AVC/H.264 video encoder that can be Blu-ray *Player* [not software} compatible [depending on settings] and it's included in the often used ffmpeg code libraries. The mpg2 encoder in ffmpeg OTOH, well, stinks. Just to get into the game with a competent, not outstanding or super great DVD, you need an encoder that does Variable Bit Rate [VBR], & ideally, if you want to do anything with video from film, can add flags when needed to play 24 fps film at 29.97 fps by showing certain frames twice [pulldown]. With a maximum of 8GB of space [dual layer DVD], VBR lets you reduce the amount of room the video takes up by reducing the bit rate, when reducing that bit rate won't matter, e.g. in scenes where everything's quiet.
That said, the video frame size used [720 x 480 or 576] isn't what's displayed by a DVD player [stand alone or software]. The picture using NTSC 720 x 480 is either *roughly* 640 x 480 or 873 x 480 on screen, 4:3 or 16:9 respectively. NTSC SD video requires 29.97 fps, PAL 25 fps, with content like movies mostly shot at 24 fps -- NTSC DVD video uses a system of flags embedded in 24 fps mpg2 video telling the player which frames to show twice to approximate 29.97 fps. DVD mpg2 video uses key frames that are complete images, with usually 15 in between frames recording only the changes between key [I] frames. Chapters are set using the time that the I frame closest to the point you select occurs. Playback uses a play list made up of the chapters to be included, while dual layer DVDs require a chapter to split the content into 2 halves. CC [or Teletext] is embedded in the mpg2, though that is not transferred over an HDMI connection. Subtitles are a series of vector graphics images with timing & coloring info [the player actually paints the subs in the colors specified for fill, outline, & background].
Most everything you see with menus is mpg2 video -- there are no still images or text on any video DVD -- the exception being button highlights, which are vector graphics similar to subtitles. Buttons themselves are similar to the hotspots used with HTML image maps. The programming logic includes things like the button order, which defines what gets selected when you're using the arrow keys on the remote. It also stores defaults when more than one audio &/or sub track is available, and ties track selection to the related buttons on the remote. A typical advanced DVD example would use introductory video & audio files, which auto opened the main menu with its audio & video files, which auto opens a duplicate menu without the intro added. That main menu would have links to additional menu pages for things like audio track & subtitle selection, with each of those menus actually being a pair, like the main menu, with a transition rather than intro video clip. Stuff like chapter & feature menus would be the same sort of affair. Menu button highlights can also get fairly involved if you go beyond simple underlines or shaded rectangles, using Photoshop layers, specifying fill & outline colors & transparency.